In the box that appears, click the second radio button, next to the words
Pop up List
Check boxes.
To the right, after the words
using value list,
is a drop-down box. Note the list the list th
Pro 2.0F!
Pro 3.0
US English - Spelling
User Dictionary
GRAND TOTAL INCOME
GRAND TOTAL INCOME\SUM
12/21/95
ADDRESS
AMOUNT PAID
COMPANY NAME
CONFIRM LTTR SENT
COUNTRY
DEAR....
ENTRY DATE
GRADE
GRAND TOTAL DUE
GRAND TOTAL DUE\SUM
GRAND TOTAL INCOME
GRAND TOTAL INCOME\SUM
(LIST
LISTA5AZ
VDEFA(
(LIST
LISTA
VDEFA(
(LIST
LISTA
Canada
VDEFA(
(LIST
LISTA8Baker Hall
Dennie Hall
Hardy Hall
Roush Hall
Wright Hall
VDEFA(
(LIST
LISTACDeveloping Self-Discipline
Dealing with Teens
Improve Your Speaking
VDEFA(
LISTA1For Women Only
Coping with Depression
Keeping Fit
VDEFA(
Name: Prefix ListB
State ListC
Sex ListD
Country ListE
Housing: Dorm ListF
Seminar 1 List
Registration NumberB
Name: TitleB
Name: FirstB
Name: MiddleB
Name: LastB
AddressB
CityB
StateB
A Phone\dayB
Company NameB
b) -
GradeB
CountryB
AddressB
CityB
StateB
PhoneB
Company NameB
GradeB
CountryB
Parent: NameB
Parent: AddressB
Parent: CityB
Parent: StateB
Parent: ZipB
Parent: PhoneB
Meeting NameB
Vision
Group\Family CodeB
Reg FeeB
Housing: DormB
Seminar CodeB
Special NeedsB
Housing: Dorm RoomB
A Seminar 1B
A Seminar 2B
!A Seminar 3B
"A Seminar 4B
#A Seminar 5B
Men in Midlife
How to Use a Lawyer
:lars
Men in Midlife
How to Use a Lawyer
Men in Midlife
How to Use a Lawyer
:tching Your Dollars
Men in Midlife
How to Use a Lawyer
:e a Lawyer
$A Seminar 6B
%A Seminar 7B
&A Seminar 8B
Parent: CountryB
Total CostB
Housing FeeB
Other 4 CostB
+A Meal FeesB
Dear....B
Dear....B
ng FeeB
Special FeesB
+A Meal FeesB
Dear....B
ecial FeesB
+A Meal FeesB
Dear....B
!A Seminar 3B
A4Dating Relationships
Family Budgeting
The Empty Nest
"A Seminar 4B
A:Improving Your Memory
For Seniors Only
All About Computers
#A Seminar 5B
A:Stretching Your Dollars
Men in Midlife
How to Use a Lawyer
ABMr.
Rev. and Mrs.
Mr. and Mrs.
Dr. and Mrs.
Reg Fee PAIDB
Meal Fees PAIDB
Housing Fee PAIDB
Other 4 PAIDB
Amount PaidB
2A Total DueB
Number of PersonsB
Reg Date PdB
Meal Date PdB
Lodging Date PdB
Special exp Date PdB
8A Reg NotesB
Meal NotesB
Lodging NotesB
Other 4 NotesB
Other 1 NotesB
Other 2 NotesB
Other 3 NotesB
Other 1 PAIDther 3 NotesB
Other 1 PAIDG
Other 2 PAIDB
Other 3 PAIDB
Other 1 Date PdB
Other 2 Date PdB
Other 3 Date PdB
Other 1 CostB
Other 2 CostB
Other 3 CostB
Roommate PrefB
Housing: OtherB
Roommate RelationshipB
Payee?B
Special Needs NotesB
Misc. NotesB
Today's DateB
Sem 1 LeaderB
M Dave Rahn
Sem 2 LeaderB
Ray Seilhamer
Sem 3 LeaderB
Mark Lamport
Sem 4 LeaderB
Ron Ramsey
Grand Total DueB
Grand Total PaidB
Grand Total IncomeB
Grand Total Due\sumB
Grand Total Paid\sumB
Grand Total Income\sumB
Total RegistrantsB
Total Reg FeesB
Total MealsB
Total HousingB
Entry DateB
Confirm Lttr SentB
Handling Own LodgingB
Staying in DormB
Meals?B
Hello!B
Last ModifiedB
BirthdayB
Payment
Codes
List--Housing
Notes
Sem 1
Profile
List--Payees
Summary Info
Label Set-up
Large Labels/5163
@%A List--Age
List--Address
Nametags
ddress
Nametags
Nametags
Help--Label Setup
Help--Label Setup
Help--Label Setup
Help--Label Setup
Help--Label Setup
Help--Label Setup
Help--Label Setup
Help--Label Setup
Help--Label Setup
Help--Label Setup
-Label Setup
Help--Label Setup
Help--Label Setup
Help--Label Setup
Help--Label Setup
Help--Label Setup
Help--Label Setup
Help--Label Setup
Help--Label Setup
el Setup
Help--Label Setup
Help--Label Setup
r 1 PAIDB
Small Labels/5160
UNUSED Tab
Hello!
Sem 9
Sem 10
Sem 11
Sem 12
Sem 13
Sem 14
Sem 2
Sem 3
Sem 4
Sem 5
Sem 6
Sem 7
Sem 8
Confirm Letter
Help Graphic
Graphic
Personal InfoB
Sort/Seminar 10
Sort/Seminar 11
Sort/Seminar 12
Sort/Seminar 13
Open Conventions
Open Seminar Titles
Open Seminar Times
Test/Copy-Paste Seminar
Set Help/Seminar Times
"Seminar Times"
Seminar TimesB
SET HELP SCRIPTS
---------------------
9/15/97
mbering
Set Help Heading
Set Help/Intro
Set Help/Set-up
Set Help/Overview
Set Help/Button Bar
Set Help/Codes
Confirm Letter
Do this person need meals?
Relationship
Roommate
Preference
Other
Lodging
Number
Main Entry
Labels
Print
Profile
Confirm
Letter
Summary
Letter Sent?u
ETo Find New Registrations
From
Symbol
menu on the left toolbar (in Find mode), choose the appropriate symbol and then type the date you want (Example: 5/27/94). The red checkmark to the immediate left inserts the symbol for
Equal to or greater than
followed by today
s date, which you can modify to get the date you want.
Letter Sent?u
First Name
E Last Name
Entry Datey
Find Againz
Group Code{
Reg. Number}
Company Name~
State
@ Last Name
First Name
BqType the name of the person or other
criteria, and then hit your ENTER key. You only need to type a few letters.
Main Entry
Labels
Profile
Confirm
Letter
Payment
the person or other
criteria, and then hit your ENTER key. You only need to type a few letters.
ve designed a whole lot of FileMaker databases. This one was originally created for the various conferences, seminars, conventions, and other events hosted by the organization which writes my bi-weekly paychecks. I posted the initial version in 1995, and now it
s being used in a wide variety of settings-- colleges, businesses, nonprofit groups, civic groups, professional organizations, blah blah blah.
In mid-1996, I totally overhauled the thing for File
Maker 3.0 and applied a tabs metaphor. Since then I
ve tinkered around with it various times, making a variety of further refinements. That brings us up to version 2.2.
If you decide you like this database and send me $20, I
ll send you the password so you can fully use it and customize it to your heart
s content. But whoa! You
re nowhere near that point yet. You downloaded this just to take a look and see what it was all about. You can click on the button at the bottom, or keep readin
Test/SeminarsB
8/5/97
8/16/59
How to Pay
tJames Smith
Spouse
M#Is a diabetic. Needs special meals.
P Dave Rahn
Main Entry
Labels
Print
Confirm
Letter
Find and List All Payees
UNUSED
List by Dorm & Room
Sort & List by Age
O)List Payees Needing
Confirmation Letters
List Children Only
UNUSED
W Addresses
Housing
Payees
Registrants by Age
UNUSED
Sorting
Lists
Summary
yeesu
SORT SCREEN
PaymentB
List--Regist InfoB
Yesf6
Yesf6
Hello!B
Entry Date}
Renumber
Registration
Numbers
:Go to List, Sorted with the Highest Group Codes at the Top
Family/Group Code
Meeting Name
Registration Number
e&Make a New Record
for a Member of....
THIS GROUP / FAMILY
A NEW GROUP / FAMILY
Date Last Modified
vA8Are you setting this up for the first time?
(click here)
Main Entry
Labels
Print
Profile
Summary
Rm #T
LodgingU
RoommateV
Namec
Main Entrye
Findg
Printj
Helpk
Profilel
Find Allm
Housingn
Housings
Lodgingu
Page ##v
Namey
Groupz
Roommate{
Lodging|
Rm #~
Meals?
Meals?
NotesB
Misc. Notes
Special Needs Notes
UNUSED
Seminars
Personal
Information
Housing
Other
Notes
Payment
Main Entry
Labels
Print
Profile
Confirm
Letter
OTHER NOTES
OTHER NOTES
Letter/oldB
Sem 3B
Personal Info
Housing
Seminars
Find Screen
Sort & Liste
Sort & List
SeminarR
GroupU
Name]
Main Entry_
Finda
Printd
Helpe
Profilef
Find Allh
Seminarsk
Sortm
Session 1 Seminars
Group
Seminar
Page ##
Seminar 1
SeminarR
GroupU
Session 8 Seminars
Group
Seminar
Page ##
p Seminar 8
Main Entry
Print
Profile
Find All
Seminars
Name: Prefix ListB
State ListC
Sex ListD
Parent: Country ListE
Housing: Dorm ListF
Seminar 1 ListG
Seminar 2 ListH
Seminar 3 ListI
Seminar 4 ListJ
Seminar 5 ListK
Seminar 6 ListL
Seminar 7 ListM
Seminar 8 ListN
Other 3 PAID ListO
Number of Persons ListP
Housing: Other ListQ
Roomate Relationship ListR
Meals? ListS
Confirm Lttr Sent ListT
Intro PageU
Seminar CodeV
Days of WeekW
Intro HelpX
Help Categories/LeftY
Heading NumbersZ
Help Categories/Right
FMRLA
FMRLA
FMRLA
FMRLA
Seminar TitlesB
Seminar TimesC
HelpD
Help\Headings
communityB
community
serviceB
findingA
finding
serviceB
deniseD
denise
rayburnD
jamesB
james
smithB
jillA
smithA
rayburnD
smithA
detroitD
detroit
louisA
orlandoE
orlando
louis
Letter Part 1B
Letter Part 2B
Letter Part 3B
Letter All CostsB
3 & "
= ""
"$0" & "
"$" &
") &
+ = ""
"$0" & "
"$" &
+ & "
") &
) = ""
"$0" & "
"$" &
) & "
") &
* = ""
"$0" & "
"$" &
* & "
") &
E = ""
"$0" & "
"$" &
< = ""
" [" &
< & "]" & "
") &
F = ""
"$" &
= = ""B
" [" &
= & "]" & "
") &
G = ""
"$" &
= = ""
" [" &
= & "]"))))
Group LetterB
Hello!B
Last ModifiedB
BirthdayB
See the number 1 radio button highlighted on the right? Below is the list of seminars offered during the first time slot. Click on one, and it'll be inserted in slot 1 on the left.
See how that works? Now the number 2 button is selected, and the list shows seminars for the second slot. Click on one to insert it on the left.
CNow the number 3 radio button is chosen, and you've got a new list.
hThe buttons will keep advancing oneBx at a time until you're done filling in the person's seminar choices.
Simple, huh?
imple, huh?
SheilaE
DitmerF
987 First StreetG
DetroitH
98765
7/3/97
ion 7
Small Label AddressB
Help Head\setB
Seminars Tab
Other Notes
Payment
Seminar Titles
Seminar Titles
Payment
Seminar Titles
Seminar Titles
General Information
HelpB
Set Help/Seminar Titles
"Seminar Titles"
Seminar TitlesB
"Seminar Titles"
Seminar TitlesB
Dear.... Note
Toggle Letter Sent/Yes or No
Message--Introduction
Set Introduction
Set What This Does
Set How to Pay
Set After You Pay
Preview Letter
Print Letter
Sort/Lodging and Room #
Sort/Other Lodging
Sort/Meals?
Sort/Total Due
Sort/Amount Paid
Sort/Total Cost
Sort/Lodging List
Paste Seminar from Portal
Toggle Meals Yes/No
Open Conventions
Open Seminar Titles
Open Seminar Times
Test/Copy-Paste Seminar
Test/Copy-Paste repeating
Find & List from Portal
Note/Seminar Portal
Note/Seminar Portal List
Note/Setup on Codes screen
Note/Meeting Name
Roomate Pref index
Increase Help ID Number by 1
Decrease Help ID Number by 1
Set Subject::Subject
Help/Go to Specific Help Record
Go Help/Renumbering
---------------------
SET HELP SCRIPTS
Set Help Heading
Set Help/Intro
Set Help/Set-up
Set Help/Overview
Set Help/Button Bar
Set Help/Codes
Set Help/Personal Info
Note\Age
"Labels"
LabelsB
Note\Same as Above
Cancel
This button, "Same as Above," copies the address from "General Information" into the address blanks below. Saves retyping.
ping.
For...Q
PaidS
CostU
GroupV
CityY
Namek
Payeesl
Paymentq
Payeess
Page ##t
Namev
City & Statex
Groupy
Total
Costz
Amt.
Paid{
Total
For...}
Find Payees
Main Entry
Print
Find All
Labels
For...Q
Total
Amt.
PaidS
Total
CostT
GroupV
CityX
Persons Responsible for PaymentY
Yesf6
Yesf6
"Personal Info"
Personal InfoB
Sort/Seminar 13
Sort/Seminar 14
Sort/Groups/Desc Order
p$Sort/Group Letter & Church ?????????
Go/People/Sort Age
Go/Add List/Sort grp/desc
x,Find----------------------------------------
Find/Seminar 1
Find/List Payees
List--Find Payees w/o confirm
Find all Children
Find/List Everybody
,Misc----------------------------------------
New Family
New Mem of This Family
Confirm: Today's Date
Letter Sent--Yes
Reserialize Reg #s
Enter Today's Date
Print This Record
Preview/Print
Find Date
Enter Entry Date
Labels--Find Payees w/o confirm
Labels/Find All Payees
Labels--Preview Small
Labels--Preview Large
Labels--Print Small
Labels--Print Large
Labels--Preview Nametags
Labels--Print Nametags
Copy/Parent/Guardian Address
%Insert Today's Date/all found letters
Note\Same as Above
Note\Special Needs
Note\seminar sort
Note\Group Code
Note\Entry & Modify Dates
Note\List
Note\Age
in Dorm
` = "Yes"
` = "No"
"Yes"
YesE!
` = ""
"Yes"
Dear.... Note
ent/Case
` = ""
"Yes"
` = "Yes"
"No"
` = "No"
"Yes")
Dear.... Note
Nametags
(3x4)
Nametags
(3x4)T"
LABEL SET-UP
Nametags
(3x4)
Find....
Set Help/Housing
"Housing"
HousingB
Set Help/Seminars Tab
"Seminars Tab"
Seminars TabB
Set Help/Other Notes
"Other Notes"
Other NotesB
Set Help/Payment
"Payment"
PaymentB
Set Help/Lists
"Lists"
ListsB
Set Help/Labels
Note\Special Needs
Cancel
Examples of Special Needs: handicaps, diet, medical conditions, housing arrangements.
Go/Label setup
Find....
+A List--AgeB
Find....
CompanyX
Group[
Namec
Main Entrye
Findf
Labelsg
Printj
Helpk
Profilel
Find Allm
Grades
List Children Onlyw
Listx
Registrants by Agez
Page ##{
Name}
Group~
Company
Grade
Group LetterU
TestV
ChurchX
GroupY
Groups & CodesZ
Reg. #[
Groups & Codes
Group
Church
Find....
List--AddressB
erenceB
Yesf6
Yesf6
W Phone\dayX
StateY
CityZ
Address\
Group]
Nameg
Main Entryi
Findj
Labelsk
Printn
Helpo
Profileq
Find Allr
Address Listt
Sortv
Listw
Address List|
Page ##}
Group
Address
State
E Phone\day
odging
$ Due
Group
Lodging
Other Lodging
$ Due
YOU CAN CALL ME....M!August 11-14, 1994
Huntington, INN
Convention Name
List--Seminar 5B
Find....
Semlist test
SeminarR
GroupU
Session 7 Seminars
Group
Seminar
Page ##
Seminar 7
Main Entry
Print
Profile
Find All
Seminars
Yesf6
Yesf6
Sem 8B
= "47"
"Confirmation Letter"
Confirmation Letter['
= "53"
"Sort"
Sort]'
= "55"
"Summary Info"
Summary Info_'
= "58"
"Profile"
Profilea'
= "59"
"Find Screen"
Find Screenc'
= "61"
"Seminar Titles"
Seminar Titlese'
= "65"
"Seminar Times"
Seminar Times
Set Help/Set-up
"Set-up"
Set-upB
Set Help/Overview
"Overview"
OverviewB
Set Help/Button Bar
"Button Bar"
Button BarB
Set Help/Codes
"Codes"
CodesB
Set Help/Intro
"Intro"
IntroB
Set Help/Personal Info
FPTHA-Giggy:Conventions/Seminars
:SeminarTimes.FP3
FaliA
Giggy
SeminarTimes.FP3
iFMP3FMP3
Conventions/Seminars
-Giggy:Conventions/Seminars
:SeminarTimes.FP3
MSPCA
NAMEA
SeminarTimes.FP3
RPTHA
SeminarTimes.FP3
alisA
Giggy
SeminarTimes.FP3
iFMP3FMP3
Conventions/Seminars
-Giggy:Conventions/Seminars
:SeminarTimes.FP3
= "1"
"Intro"
IntroC'
= "10"
"Set-up"
Set-upE'
= "13"
"Overview"
OverviewG'
= "15"
"Button Bar"
Button BarI'
= "19"
"Codes"
CodesK'
= "24"
"Personal Info"
Personal InfoM'
= "26"
"Housing"
HousingO'
= "30"
"Seminars Tab"
Seminars TabQ'
= "33"
"Other Notes"
Other NotesS'
= "34"
"Payment"
PaymentU'
= "40"
"Lists"
ListsW'
= "41"
"Labels"
Labels
Billy Smith
5Billy Smith
123 Vine Street
St. Louis, MO 45678-3333
1-13X
Baker HallZ
Developing Self Discipline`
For Women Onlya
Keeping Fitb
Improving Your Memoryc
Stretching Your Dollarsd
Finding a New Jobe
Starting Your Own Businessf
Helping Othersg
0l Mr. Smithm
Familyt
8/4/95| Area tour
James Smith
Child
9/15/97
P Dave Rahn
Ray Seilhamer
Mark Lamport
Ron Ramsey
9/15/97
9/15/97
8/16/86
How to Pay
|FBilly Smith
123 Vine Street
St. Louis, MO 45678-3333
Dear Mr. Smith:
Baker Hall
Smith, Billy
Billy Smith
Developing Self Discipline
Keeping Fit
Family Budgeting
For Seniors Only
Stretching Your Dollars
Planning for Retirement
St. Louis, MO 45678-3333
St. Louis, MO
$0 [Area tour]
]This person isn't responsible for payment, and therefore shouldn't get a confirmation letter.
Baker Hall
5678-3333
LarryE
WalkerF PO Box 19G
OrlandoH
87654J
456-123-9876K
SouthL
Dr. Milt WalkerQ PO Box 19R
OrlandoS
87654U
456-123-9876W
03-12X
Dealing with Teens`
Keeping Fita
Family Budgetingb
For Seniors Onlyc
Stretching Your Dollarsd
Finding a New Jobe
All About Investingf
Helping Othersg
Larrym
0s 3 Personst
8/4/95w
8/4/95
Comfort Inn
9/15/97
P Dave Rahn
Ray Seilhamer
Mark Lamport
Ron Ramsey
9/15/97
9/15/97
3/17/79
|:Mr. Larry Walker
PO Box 19
Orlando, FL 87654
Dear Larry:
Comfort Inn
Walker, Larry
Larry Walker
Orlando, FL 87654
Orlando, FL
$0$0$0
]This person isn't responsible for payment, and therefore shouldn't get a confirmation letter.
Comfort Inn
Mr. Larry Walker
-Mr. Larry Walker
PO Box 19
Orlando, FL 87654
BillyE
SmithF
123 Vine StreetG St. LouisH
45678-3333J
123-456-7890
AdamE
SmithF
PO Box 63
123 Vine StreetG St. LouisH
45678J
123-456-7890K
MidwestL
CanadaP
Mr. and Mrs. James SmithQ
123 Vine StreetR St. LouisS
45678U
234-567-9012W
01-12X
Baker HallZ
Developing Self Discipline`
Keeping Fita
Family Budgetingb
For Seniors Onlyc
Men in Midlifed
Community Servicee
Starting Your Own Businessf
Helping Othersg
0l Mr. Smithm
Familyt
8/4/95| Area tour
James Smith
Parent
9/15/97
P Dave Rahn
Ray Seilhamer
Mark Lamport
Ron Ramsey
9/15/97
9/15/97
4/12/87
234-567-9012
|JAdam Smith
PO Box 63
123 Vine Street
St. Louis, MO 45678
Dear Mr. Smith:
Baker Hall
Smith, Adam
Adam Smith
St. Louis, MO 45678 Canada
St. Louis, MO
$0 [Area tour]
]This person isn't responsible for payment, and therefore shouldn't get a confirmation letter.
Baker Hall
Adam Smith
MO 45678 Canada
Find....
Profile\housingB
= ""
""
J = ""
= ""
J = ""
Label Return AddressB
Name\Whole including prefixB
City Plus StateB
& ", " &
Message\housingB
= ""
J = ""
d = "Yes"
"Make a selection from one of the two lists, Dorm and Other Lodging. Check only ONE box in ONE list."
"You checked a box in both categories - Dorm and Other Lodging. Can't do that. Leave all boxes unchecked in one of the lists."
J = ""
= ""
"You haven't yet assigned a room to this person."
J = ""
""
I = ""
"Does this person hav
I = ""
"Does this person hav
<Mr. James W. Smith
123 Vine Street
St. Louis, MO 45678-3333
Mrs.C ElizabethE
WalkerF PO Box 19G
OrlandoH
87654J
456-123-9876K
SouthL
03-11X
Dealing with Teens`
For Women Onlya
Keeping Fitb
For Seniors Onlyc
Stretching Your Dollarsd
Community Servicee
All About Investingf
Planning for Retirementh
Dr. Walkerm
0s 2 Personst
8/4/95w
8/4/95
Comfort Inn
9/15/97
P Dave Rahn
Ray Seilhamer
Mark Lamport
Ron Ramsey
9/15/97
9/15/97
7/19/51
|DMrs. Elizabeth Walker
PO Box 19
Orlando, FL 87654
Dear Dr. Walker:
Comfort Inn
Walker, Elizabeth
Elizabeth Walker
Orlando, FL 87654
Orlando, FL
Note/Meeting Name
Cancel
This is a global field. Whatever you enter here will appear in EVERY record. That's what you want. Change it in one record, and it'll be changed in ALL records. Which, again, is what you want.
Go Help/Renumbering
) = "Personal Info"
Personal Info
Note/Meeting Name
Cancel
This is a global field. Whatever you enter here will appear in EVERY record. That's what you want. Change it in one record, and it'll be changed in ALL records. Which, again, is what you want.
Go Help/Renumbering
Lodging\listB
= ""
""
J = ""
= ""
J = ""
""
"???")
Name\Last plus firstB
& ", " &
= ""
" " &
Name\First plus lastB
& " " &
= ""
& " ") &
A Seminar 9B
Seminar 10B
Seminar 11B
Seminar 12B
Seminar 13B
Seminar 14B
) = "Summary Info"
Summary Info
) = "Sort & List"
Sort & List
) = "Label Set-up"
Label Set-up
) = "Find Screen"
Find Screen
) = "List--Address"
) = "List--Payees"
) = "List--Age"
) = "List--Housing"
List--Address
List--Payees
List--Age
List--Housing
1 def
/ys 1 def
/botx 0 def
/overl
ap 0 def
/wdist 18 def
0 2 mul fhsetspreadsize
0 0 ne {/df 0 def /clipflatness 0 def} if
/maxsteps 256 def
/forcemaxsteps false def
/minsteps 0 def
userdict begin /AGDOrigMtx matrix currentmatrix def end
{eofill}{fill}ifelse}{{eoclip}{clip}ifelse fp}ifelse}a{setpacking}if end end}if
userdict begin P3_d begin/txrErrStr(A texture used in u
SuperPaint's draw layer is too large to print on this printer.)def end end
h304 211 1 index neg 1 index neg matrix translate 3 1 roll
currentpoint 2 copy matrix translate 6 1
Go/Find Help/Browse
Sort/Seminar 5
&nd....
roll
336 243 currentpoint 1 index 6 index sub 4 index 9 index sub div
1 index 6 index sub 4 index 9 index sub div
matrix scale 11 1 roll
[ 9 1 roll cleartomark
3 2 roll matrw
ix concatmatrix
exch matrix concatmatrix
/P2_tp exch def
P2_b -1 gx end
P2_b mk end{md/bn known{bn}if}if
Mmatrix currentmatrix aload pop count 6 roll
P2_b mk end{md/bu known{bu}if}if
Fuserdict beginx
P3_d begin
count -6 roll
matrix astore /P3_tm exch def
)end end P2_b mk end{md/bn known{bn}if}if
emd/av known{md/av get 80 ly
t md/xspnt known or{userdict begin P3_d begin /cim load end end exec}if}if
Go/Find Help/Browse
Sort/Seminar 5
&nd....
F1F19
Go/Find Help/Browse
Sort/Seminar 5
&nd....
)J)J!
F1F19
)J)J!
F1F19
)J)J!
F1F19
)J)J!
)J)J!
)J)J!
Go/Find Help/Browse
Sort/Seminar 5
&nd....
Go/Find Help/Browse
Sort/Seminar 5
&nd....
Go/Find Help/Browse
Sort/Seminar 5
&nd....
Go/Find Help/Browse
Sort/Seminar 5
&nd....
Go/Find Help/Browse
Sort/Seminar 5
&nd....
ffffff
ffff33
ff33ff
ff3333
Go/Find Help/Browse
Sort/Seminar 5
&nd....
33ffff
33ff33
3333H
3333ff
333333
Go/Find Help/Browse
Sort/Seminar 5
&nd....
wwwwww
UUUUUU
DDDDDD
""""""
T *TTi*TiT*
TSort/Seminar 5
&nd....
SeminarR
GroupU
Session 6 Seminars
Group
Seminar
Page ##
Seminar 6
Main Entry
Print
Profile
Find All
Seminars
Ms. Sheila Ditmer
5Ms. Sheila Ditmer
987 First Street
Detroit, MI 98765
MiltD
WalkerF PO Box 19G
OrlandoH
87654J
456-123-9876K
SouthL
03-10X
Developing Self Discipline`
Keeping Fita
Family Budgetingb
For Seniors Onlyc
Men in Midlifed
Community Servicee
All About Investingf
Planning for Retirementh
Dr. Walkerm
180s 2 Personst
8/4/95w
8/4/95| Area Tour}
BBall Tourney
Comfort Inn
9/15/97
Mrs. Jill Smith
4Mrs. Jill Smith
123 Vine Street
St. Louis, MO 45678
45678J
123-456-7890K
MidwestL
CanadaP
Mr. and Mrs. James SmithQ
123 Vine StreetR St. LouisS
45678U
234-567-9012W
01-12X
Baker HallZ
Developing Self Discipline`
Keeping Fita
Family Budgetingb
For Seniors Onlyc
Men in Midlifed
Community Servicee
Starting Your Own Businessf
Helping Othersg
Familyt
8/4/95| Area tour
James Smith
Parent
7/3/97
P Dave Rahn
Ray Seilhamer
Mark Lamport
Ron Ramsey
8/4/95
9/15/97
4/12/87
234-567-9012
|7Adam Smith
123 Vine Street
St. Louis, MO 45678
Dear :
Baker Hall
Smith, Adam
Adam Smith
St. Louis, MO 45678 Canada
St. Louis, MO
$0 [Area tour]
]This person isn't responsible for payment, and therefore shouldn't get a confirmation letter.
Baker Hall
Adam Smith
= ""
& " ") &
& " " &
= ""
& " ") &
So here
s a little of what it has.
Information on attendees, of course--name, address, phone, age, sex, email, etc.
Payment information, including how much they
ve paid and how much they still owe.
Lodging info, whether they
re staying at your facilities or somewhere else. Room assignments and roommate preferences.
Confirmation letters which include what the person has paid and still owes.
Some pretty good help screens built in.
A screen with summary information on the even
t--how many people have registered, how many are signed up for meals or lodging, how much money has come in so far, how much hasn
t, etc.
You can do several types of labels, including nametags.
Places for eight seminar time slots, with any number of seminars in each.
All kinds of ways to sort information.
You can customize this database to pieces, tailoring it to fit your specific needs and adapting it to fit different types of events as they arise.
If you want the password so yo
urse, you might also want to just delete this field entirely from the
Define Fields
menu, to get it out of your way. Doesn
t matter to me.
m Steve, and I love FileMaker.
ve designed a whole lot of FileMaker databases. This one was originally created for the various conferences, seminars, conventions, and other events hosted by the organization which writes my bi-weekly paychecks. I posted the initial version in 1995, and now it
s being used in a wide variety of settings-- colleges, businesses, nonprofit groups, civic groups, professional organizations, blah blah blah.
In mid-1996, I totally overhauled the thing for File
Mrs.C
JillE
SmithF
123 Vine StreetG St. LouisH
45678St. Louis, MO 45678-3333
Mrs.C
JillE
SmithF
123 Vine StreetG St. LouisH
456787
ROOMMATE PREF
ROOMMATE RELATIONSHIP
SEM 1 LEADER
SEM 2 LEADER
SEM 3 LEADER
SEM 4 LEADER
SEM ENTRY MESSAGE
SEMINAR 1
SEMINAR 10
SEMINAR 11
SEMINAR 12
SEMINAR 13
SEMINAR 14
SEMINAR 2
SEMINAR 3
! SEMINAR 4
" SEMINAR 5
# SEMINAR 6
$ SEMINAR 7
% SEMINAR 8
& SEMINAR 9
SEMINAR CODE
SESSION DAYS
SESSION TIMES
SESSIONS NUMBER
SESSIONS REPEATING
SET HELP HEADING
SET HELP NUMBER
SET SUBJECT
SMALL LABEL ADDRESS
SPECIAL EXP DATE PD
SPECIAL NEEDS
SPECIAL NEEDS NOTES
STATE
STAYING IN DORM
TAB 1
TAB 2
TAB 3
TAB 4
TAB 5
TAB 6
TAB 7
right which says
Access Entire File.
Hit the
Change
button, and then the
button.
You should now be able to get into the file without entering a password.
3. Get rid of this screen. To do that:
From this screen, go into Layout mode.
From the Mode menu, choose
Delete Layout.
ll be asked if you really want to do this. You do.
From the Edit menu, choose
Preferences.
In the box that appears, there
s a drop-down box. Choose
Document.
A few
lines down, you can determine which layout you want the file to open onto when you first get into the file (after the words
Switch to layout
). I suggest setting it onto the layout
Personal Info.
By the way: The information in this screen will still be available after you delete the layout. There
s a field called
Hello!
which is a global field, meaning it contains the same information in every record. Just place the field onto a layout, and you
ll be able to read this message. Of co
u can fully use this database, you can send $20 in one of two ways:
1. Send $20 (check or cash) directly to me at:
Steve Dennie
3014 Carrington Dr.
Fort Wayne, IN 46804
sdennie@kagi.com (or, second choice, sdennie@ub.org)
Include your email address, if you have one, and I
ll send the password that way.
2. Use the bundled
Register Conventions
application to pay through Kagi Shareware (which manages the payment process for shareware authors).
Kagi offers a
number of payment options, including credit cards and a First Virtual account. They
ll keep $2 for themselves, but that
s okay with me if it makes it easier for you to buy this file.
After you register, I
ll be glad to answer questions or give advice via email. Also, I
ll notify you via email about updates I make.
After getting the password, you
ll want to do the following:
1. Set up your own value lists (like dormitory names). To do that:
Go into Layout mode (Command-L).
TSort/Seminar 5
&nd....
3333D
ffffff
ffff33
ff33ff
ff3333
TSort/Seminar 5
&nd....
33ffff
33ff33
3333ff
333333
TSort/Seminar 5
&nd....
wwwwww
UUUUUU
DDDDDD
""""""
TSort/Seminar 5
&nd....
"Payment"
"40"
"40"
"Lists"
"41"
"46"
"Labels"
"47"
"52"
"Confirmation Letter"
"53"
"54"
"Sort"
"55"
"57"
"Summary Info"
"58"
"58"
"Profile"
"59"
"60"
"Find Screen"
"61"
"64"
"Seminar Titles"
"65"
"66"
"Seminar Times"
wwwwww
UUUUUU
DDDDDD
""""""
TSort/Seminar 5
&nd....
3333D
TSort/Seminar 5
&nd....
ffffff
ffff33
ff33ff
ff3333
33ffff
33ff33
3333ff
333333
TSort/Seminar 5
&nd....
wwwwww
UUUUUU
DDDDDD
""""""
TSort/Seminar 5
&nd....
TSort/Seminar 5
&nd....
ck once on the field you want to change. That selects the field.
Choose
Field Format
from the
Format
menu.
In the box that appears, click the second radio button, next to the words
Pop up List
Check boxes.
To the right, after the words
using value list,
is a drop-down box. Note the list that
s currently displayed. That
s the one you want to change. Then Choose the very last item, which is
Define value lists....
In the list in the upper left, select the l
ist you want to change. Replace the items listed with your own list.
Hit the
button. Then get out by hitting the
button.
2. Get rid of the password protection. To do that:
Use the password to get into this file. That
s obvious.
From the File menu, go to
Access Privileges
and then choose
Define Passwords...
Select the password name which I sent you, and then hit the
Delete
button.
Select the (no password) entry, and then click in the box to the
Hi There!
VSteve Dennie Software
3014 Carrington Dr.
Fort Wayne, IN 46804
sdennie@concentric.net
KIf you want the password
so you can fully use this
database, send $30 to:
AEnough! I just want to browse the database to see what it
s like.
Introduction
What This Does
How to Pay
After You Pay
To Begin....
s it Do?
Information
Features
Other Stuff
The Cost
s it Cost?
How to Pay
After You Pay
Password Protection
Remove this Screen
Finally....
exp Date Pd
Other 1 Date Pd
Other 2 Date Pd
Other 3 Date Pd
Reg Notes
Meal Notes
Lodging Notes
Special Notes
Other 1 Notes
Other 2 Notesher 2 Notes
Retirement
TSort/Seminar 5
&nd....
3333D
TSort/Seminar 5
&nd....
ffffff
ffff33
ff33ff
ff3333
33ffff
33ff33
3333ff
333333
TSort/Seminar 5
&nd....
wwwwww
UUUUUU
DDDDDD
""""""
TSort/Seminar 5
&nd....
TSort/Seminar 5
&nd....
Message\not payeeB
3) = "-10"
"-10"
"This person isn't responsible for payment, and therefore shouldn't get a confirmation letter.")
]This person isn't responsible for payment, and therefore shouldn't get a confirmation letter.
Set Help NumberB
Set Help HeadingB
"1"
"9"
"Intro"
"10"
"12"
"Set-up"
"13"
"14"
"Overview"
"15"
"18"
"Button Bar"
"19"
"23"
"Codes"
"24"
"25"
"Personal Info"
"26"
"29"
"Housing"
"30"
"32"
"Seminars Tab"
"33"
"33"
"Other Notes"
"34"
/setoverprint{pop}ndf
/currentoverprint false ndf
/cmykbufs2gray{
0 1 2 index length 1 sub
4 index 1 index get 0.3 mul
4 index 2 index get 0.59 mul
4 index 3 index get 0.11 mul
4 index 4 index get
add add add cvi 255 min
255 exch sub
2 index 3 1 roll put
}for
4 1 roll pop pop pop
/colorimage{
pop pop
5 -1 roll/exec cvx
6 -1 roll/exec cvx
7 -1 roll/exec cvx
8 -1 roll/exec cvx
/cmykbufs2gray cvx
]cvx
image
%. version 47.1 on Linotronic of Postscript defines c
olorimage incorrectly (rgb model only)
version cvr 47.1 le
statusdict /product get (Lino) anchorsearch{pop pop true}{pop false}ifelse
e a roommate preference? If so, type the name in the blank on the far right."
J = ""
""
""
K = ""
"What is the relationship of this person to the Roommate Preference? You have six choices on the right.")
cMake a selection from one of the two lists, Dorm and Other Lodging. Check only ONE box in ONE list.
|You checked a box in both categories - Dorm and Other Lodging. Can't do that. Leave all boxes unchecked in one of the lists.
/You haven't yet assigned a room to this person.
`Does this person have a roommate preference? If so, type the name in the blank on the far right.
fWhat is the relationship of this person to the Roommate Preference? You have six choices on the right.
W'Is this person responsible for payment?sible for payment?
ExpenseExpenseExpensed
Expense
ExpenseCost
Expenset
Expenset
Expenset
Expenset
Expenset
Expense
Amount Paidense
Amount Paid
Amount Paide
Amount Paidunt Paidmount Paidmount Paid
p Total Due
Amount Paid Due
Amount Paid Due
Amount Paid Due
Amount Paid Due
Amount Paid Due
Amount Paidmount Paidmount Paidmount Paid Due
Amount Paid Due
Amount Paid Due
Amount Paid Due
Amount Paid Due
Amount Paid Due
Amount Paid Due
Amount Paid Due
Amount Paid Due
Amount Paid Due
Amount Paid Due
Amount Paid Due
Amount Paid Due
Amount Paid Due
Amount Paid Due
Amount Paid Due
Amount Paid Due
Amount Paid Due
Amount Paid Due
Amount Paid Due
Amount Paid Due
Amount Paidq
Amount PaidPaidPaidPaidPaidPaidPaidPaidPaidxpense
p Total Due
Amount Paid
Expense
p Total Due
Amount Paidotal Due
Amount PaidTotal Due
Amount Paid
&nd....
Go/Address list
Note\Entry & Modify Dates
Cancel
Both of these dates are entered automatically. The Creation Date is when you, uh, created the record. The "Date Last Modified" field tells when you last made changes to this record. Like, duh!
Note\Age
Cancel
The person's age is entered automatically. It is calculated from the birthday given in the previous record.
from the Mode menu. Click on this screen and move it up, so it
s right after
Payment.
4. From the
Script
menu, choose
Scriptmaker.
About eight places down is a script called
Go/UNUSED Screen.
At the bottom, insert your own name (Go/YourOwnName), and then hit the
Rename
button on the right (don
t hit return, or you
ll create a brand new script).
5. And, of course,CM you
ll want to delete this message.
Other than that, it
s all ready to go.
Sem Entry MessageB
= ""
= "1"
"See the number 1 radio button highlighted on the right? Below is the list of seminars offered during the first time slot. Click on one, and it'll be inserted in slot 1 on the left."
= ""
"See how that works? Now the number 2 button is selected, and the list shows seminars for the second slot. Click on one to insert it on the left."
! = ""
"Now the number 3 radio button is chosen, and youB
've got a new list." & "
" & "The buttons will keep advancing one at a time until you're done filling in the person's seminar choices."
" = ""
" & "Simple, huh?")
Main Entry
Labels
Print
Profile
Confirm
Letter
&Make a New Record
for a Member of....
THIS GROUP / FAMILY
A NEW GROUP / FAMILY
Go to
Address
Mth / Day / Yr
email
Same Address as Above
333333
wwwwww
UUUUUU
DDDDDD
""""""
ffffff
ffff33
ff33ff
ff3333
33ffff
33ff33
SeminarR
GroupU
Session 13 Seminars
Group
Seminar
Page ##
Seminar 13
Main Entry
Print
Profile
Find All
Seminars
/Seminar 5
&nd....
3333D
/Seminar 5
&nd....
ffffff
ffff33
ff33ff
ff3333
33ffff
33ff33
3333ff
333333
/Seminar 5
&nd....
wwwwww
UUUUUU
DDDDDD
""""""
LEADER
Decrease Help ID Number by 1
- 1
Set Subject::Subject
Help/Go to Specific Help Record
Helvetica
Geneva
95 Helvetica Black
Friz Quadrata
2Stone Sans
Zapf Dingbats
Palatino
B Friz Quadrata Bold
Chicago
Rockwell
Times
CompactaICGBlack
Sunday
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
January
February
March
April
August
September
October
November
December
1st Quarter
2nd Quarter
3rd Quarter
4th Quarter
RENT: PHONE
PARENT: STATE
PARENT: ZIP
PHONE
REG FEE
REG FEE PAID
REGISTRATION NUMBER
SEMINAR 1
SEMINAR 2
SEMINAR 3
! SEMINAR 4
" SEMINAR 5
# SEMINAR 6
$ SEMINAR 7
% SEMINAR 8
SEMINAR CODE
SPECIAL FEES
SPECIAL FEES PAID
SPECIAL NEEDS
STATE
TOTAL COST
COMPANY NAME
LETTER PART 1
OTHER 3 DATE PD
ROOMMATE PREF
TODAY'S DATE
VDEFA(
(LIST
LISTA
(LIST
LISTA1For Women Only
Coping with Depression
Keeping Fit
VDEFA(
(LIST
LISTA4Dating Relationships
Family Budgeting
The Empty Nest
VDEFA(
(LIST
LISTA:Improving Your Memory
For Seniors Only
All About Computers
VDEFA(
(LIST
LISTA:Stretching Your Dollars
Men in Midlife
How to Use a Lawyer
VDEFA(
LISTA5Finding a New Job
Community Service
Childcare Options
VDEFA(
Name: Prefix ListB
State ListC
Sex ListD
Country ListE
Housing: Dorm ListF
Seminar 1 ListG
Seminar 2 ListH
Seminar 3 ListI
Seminar 4 ListJ
Seminar 5 List
CITY PLUS STATE
CITY PLUS STATE PLUS ZIP
S ZIP COPY
COUNTRY
DEAR....
EMAIL ADDRESS
ENTRY DATE
FAX NUMBER
GLOBAL 1
GLOBAL 2
GLOBAL 3
GLOBAL 4
GLOBAL RADIO BUTTON
GLOBAL SELECTION
GRADE
GRAND TOTAL DUE
GRAND TOTAL DUE\SUM
GRAND TOTAL INCOME
GRAND TOTAL INCOME\SUM
GRAND TOTAL PAID
GRAND TOTAL PAID\SUM
GROUP LETTER
GROUP\FAMILY CODE
HANDLING OWN LODGING
HELLO!
HOUSING FEE
HOUSING FEE PAID
HOUSING: DORM
HOUSING: OTHER
HOUSING: ROOM
LAST MODIFIED
LODGING DATE PD
LODGING NOTES
LODGING\LIST
MEAL DATE PD
5 MEAL FEES
MEAL FEES PAID
MEAL NOTES
MEALS?
MEETING CODE
MISC. NOTES
NAME: FIRST
NAME: LAST
NAME: MIDDLE
NAME: PREFIX
NAME\FIRST PLUS LAST
NAME\LAST PLUS FIRST
NUMBER OF PERSONS
OTHER 1 COST
OTHER 1 DATE PD
OTHER 1 NOTES
OTHER 1 PAID
OTHER 2 COST
OTHER 2 DATE PD
OTHER 2 NOTES
OTHER 2 PAID
OTHER 3 COST
(LIST
LISTAcBudgetel
Fairfield
Comfort Inn
Day's Inn
Guesthouse
Holiday Inn
KOA Camp
Luxbury
Signature Inn
VDEFA(
(LIST
LISTA(Child
Friend
Parent
Sibling
Spouse
Other
VDEFA(
(LIST
LISTA
VDEFA(
(LIST
Name: Prefix ListB
State ListC
Sex ListD
Parent: Country ListE
Housing: Dorm ListF
Seminar 1 ListG
Seminar 2 ListH
Seminar 3 ListI
Seminar 4 ListJ
Seminar 5 ListK
Seminar 6 ListL
Seminar 7 ListM
Seminar 8 ListN
Other 3 PAID ListO
Number of Persons ListP
Housing: Other ListQ
Roomate Relationship ListR
Payee? List
LISTA
VDEFA(
(LIST
LISTA4Introduction
What This Does
How to Pay
After You Pay
VDEFA(
(LIST
LISTA 1
VDEFA(
(LIST
LISTA8Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
Name: Prefix ListB
State ListC
Sex ListD
Parent: Country ListE
Housing: Dorm ListF
Seminar 1 ListG
Seminar 2 ListH
Seminar 3 ListI
Seminar 4 ListJ
Seminar 5 ListK
Seminar 6 ListL
Seminar 7 ListM
Seminar 8 ListN
Other 3 PAID ListO
Number of Persons ListP
Housing: Other ListQ
Roomate Relationship ListR
Meals? ListS
Confirm Lttr Sent ListT
Intro PageU
Seminar CodeV
Days of Week
FMRLA
Seminar List
HousingB
Dear....z
General Information{
Country|
Parent or Guardian} Phone\day~
State
Address
Country
Grade
Birthday
Company
State
Address
Labels
Print
UNUSED
Seminars
Personal
Information
Housing
Other
Notes
Payment
Codes
Profile
Confirm
Letter
& List
Delete this
Record
&Make a New Record
for a Member of....
THIS GROUP / FAMILY
A NEW GROUP / FAMILY
Go to
Address
Mth / Day / Yr
SeminarsB
Find ScreenB
Opening MenuB
SeminarR
GroupU
Session 14 Seminars
Group
Seminar
Page ##
Seminar 14
Main Entry
Print
Profile
Find All
Seminars
Yesf6
Yesf6
Note\seminar sort
Cancel
Clicking on this button will take you to a screen from which you can do two different things: find everyone signed up for a seminar during a particular time slot, or find everyone signed up for a specific seminar.
Go/Sort & List
A Sort--Zip
Main Entry
Labels
Print
Profile
Graphic
Summary
LClick on a red subheading in the list above to go to a specific help screen.
Codes
Button Bar
Overview
Set-up
Tab Screens
General
Personal Info
Housing
Seminars
Payment
Other Notes
Intro
Related Files
Sem Times
Sem Titles
Lists
Other
Labels
Conf. Letter
Profile
Summary Info
Find Screen
Codes
Button Bar
Overview
Set-up
Tab Screens
General
Personal Info
Housing
Seminars
Payment
Other Notes
Intro
Related Files
Sem Times
Sem Titles
Lists
Other
Labels
Conf. Letter
Profile
Summary Info
Find Screend Screensing
Seminars
Payment
Other Notes
Intro
Related Files
Sem Times
Sem TitlesLetter
Profile
Summary Info
Find Screen
Sort & ListB
= ""
& " ") &
& " " &
= ""
& " ") &
& ", " &
& " " &
) & "
"Dear " &
, & ":"
Dear
Main Entry
Labels
Print
Profile
Confirm
Letter
You can add your own fields to this screen.
Customize it to fit your needs.
Some things you
ll want to do:
1. In Layout mode, retitle the UNUSED tab on each of these screens (the Codes screen, Personal Information screen, etc.). Just click once on
UNUSED
and start typing.
2. In Layout mode, and while on this screen, choose
Layout Setup
from the
menu. Replace
UNUSED
with your own title. That will change the
UNUSED
in the upper left box of the status bar, using the descriping the descriphe descrip the descrips bar, using the descripthe descriping the descripthe descripe descrip
, choose
Scriptmaker.
About eight places down is a script called
Go/UNUSED Screen.
At the bottom, insert your own name, and then hit the
vrtomark exch 1.3 mul dup setflat exch 2 copy gt{stop}if}
{cleartomark exit}ifelse
}loop
gsave stopped grestore
{exch pop 2 index exch 1.3 mul dup 100 gt{cleartomark setflat stop}if}
{exit}ifelse
}loop
cleartomark setflat
iosv setinkoverprint
cosv setoverprint
/lfp4{_lfp4}ndf
/lfs4{_lfs4}ndf
/rfs4{_rfs4}ndf
/rfp4{_rfp4}ndf
/cvc [0 0 0 1] def
sysDict /cvc 2 index put
aload length 4 eq
{setcmykcolor}
{setspotcolor}
ifelse
}bdf
/origmtx matrix currentmatrix def
/ImMatrix matrix currentmatrix def
0 setseparationgray
/imgr {1692 1602 2304 2394 } def
/bleed 0 def
/clpr {1692 1602 2304 2394 } def
/xs 1 def
/ys 1 def
/botx 0 def
/overlap 0 def
/wdist 18 def
0 2 mul fhsetspreadsize
0 0 ne {/df 0 def /clipflatness 0 def} if
/maxsteps 256 def
/forcemaxsteps false def
-1954 -1982 translate
/currentpacking defed{false set
Intro
Set-up
Overview
Button Bar
Codes
Personal Info
Housing
Seminars Tab
Other Notes
Payment
Lists
Labels
Confirmation Letter
Summary Info
Profile
Intro
Set-up
Overview
Button Bar
Codes
Personal Info
Housing
Seminars Tab
Other Notes
Payment
Lists
Labels
Confirmation Letter
Summary Info
Profile
S&Make a New Record
for a Member of....
A NEW GROUP / FAMILY
THIS GROUP / FAMILY
W'Is this person responsible for payment?
Inserts cost and today
s date
Total Cost
Other 3
Other 2
Other 1
Notes
These expenses are for:
Other 4
Lodging
Meals
Registration
Date Pd.
Expense
p Total Due
Amount Paid
CodesB
Yesf6
Find Screen
Seminar Titles
Seminar Times
Codes
Personal Info
Housing
Seminars Tab
Other Notes
Payment
Seminar Titles
Seminar Times
Payment
Seminar Titles
Seminar Times
m Steve, and I love FileMaker.
ve designed a whole lot of FileMaker databases. This one was originally created for the various conferences, seminars, conventions, and other events hosted by the organization which writes my bi-weekly paychecks. I posted the initial version in 1995, and now it
s being used in a wide variety of settings-- colleges, businesses, nonprofit groups, civic groups, professional organizations, blah blah blah.
In mid-1996, I totally overhauled the thing for File
Maker 3.0 and applied a tabs metaphor. Since then I
ve tinkered around with it various times, making a variety of further refinements. That brings us up to version 2.2.
If you decide you like this database and send me $20, I
ll send you the password so you can fully use it and customize it to your heart
s content. But whoa! You
re nowhere near that point yet. You downloaded this just to take a look and see what it was all about. You can click on the button at the bottom, or keep readin
List--HousingB
Main Entry
Labels
Print
Profile
Confirm
Letter
Summary
Sem 1B
MidwestL
James SmithQ
123 Vine StreetR St. LouisS
45678-3333W
01-13X
Baker HallZ
Developing Self Discipline`
For Women Onlya
Keeping Fitb
Improving Your Memoryc
Stretching Your Dollarsd
Finding a New Jobe
Starting Your Own Businessf
Helping Othersg
0l Mr. Smithm
Familyt
8/4/95| Area tour
James Smith
Child
9/15/97
P Dave Rahn
Ray Seilhamer
Mark Lamport
Ron Ramsey
9/15/97
9/15/97
8/16/86
How to Pay
|FBilly Smith
123 Vine Street
St. Louis, MO 45678-3333
Dear Mr. Smith:
Baker Hall
Smith, Billy
Billy Smith
Developing Self Discipline
Keeping Fit
Family Budgeting
For Seniors Only
Stretching Your Dollars
Planning for Retirement
St. Louis, MO 45678-3333
St. Louis, MO
$0 [Area tour]
]This person isn't responsible for payment, and therefore shouldn't get a confirmation letter.
Baker Hall
Sort/Grade
Find all Children
@@-10
@@-10B
@@-11
Note\Group Code
Lodging
d/Date
Special
Cancelate
Other 1 Paid/Date
Other 2 Paid/Date
Other 3 P-10 = Payee (Example: 03-10)
-11 = Spouse (Example: 03-11)
-12 = Child 1 (Example: 03-12)
-13 = Child 2, etc. (Example: 03-13, 03-14, etc.)
Go/UNUSED Screen
Main Entry
Labels
Print
Profile
Summary
List--Seminar 2B
Yesf6
Yesf6
Yesf6
Yesf6
Sem 6B
SeminarR
GroupU
Session 4 Seminars
Group
Seminar
Page ##
Seminar 4
Main Entry
Print
Profile
Find All
Seminars
ProfileB
Yesf6
Yesf6
SheilaE
DitmerF
987 First StreetG
DetroitH
98765J
987-654-3210K
CentralL
02-10X
Roush HallZ
Developing Self Discipline`
For Women Onlya
Family Budgetingb
For Seniors Onlyc
Men in Midlifed
Finding a New Jobe
Starting Your Own Businessmith
Parent
7/3/97
P Dave Rahn
Ray Seilhamer
Mark Lamport
Ron Ramsey
8/4/95
9/15/97
4/12/87
234-567-9012
|7Adam Smith
123 Vine Street
St. Louis, MO 45678
Dear :
Baker Hall
Smith, Adam
Adam Smith
St. Louis, MO 45678
St. Louis, MO
$0 [Area tour]
]This person isn't responsible for payment, and therefore shouldn't get a confirmation letter.
Baker Hall
Adam Smith
SheilaE
DitmerF
987 First StreetG
DetroitH
98765J
987-654-3210K
CentralL
02-10X
Roush HallZ
Developing Self Discipline`
For Women Onlya
Family Budgetingb
For Seniors Onlyc
Men in Midlifed
Finding a New Jobe
Starting Your Own Businesss
w Session 6
x Session 5
y Session 4
z Session 3
{ Session 2
| Session 1
Location
Housing
Relationship
Roommate Pref.
Room #
Group
Reg. #
General Information
Parent/Guardian
Grade
Company Name
Address
Work Phone
Home Phone
email
PROFILE
Session 10
Session 11
Session 12
Session 13
Session 14
Session 9
Phones / FAX / Email
Main Entry
Labels
Print
Profile
Confirm
Letter
FAX NumberB
email addressB
Phone\homeB
Global 1B
Global 2B
Global 3B
Global 4B
Global radio buttonB
Tab 1B
Tab 2B
Tab 3B
Tab 4B
Tab 5B
Tab 6B
Tab 7B
Confirmation Return AddB
Confirmation Return AddB
Responsible
for payment?
e Amnt. Pd.
Notes
Costs
Total Cost
Other 4
Other 3
Other 2
These expenses are for:
Other 1
Lodging
Meals
Registration
r Total Due
Amount Paid
Seminars
u Session 8
v Session 7ion 7ession 7
Help GraphicB
List--PayeesB
JamesD
SmithF
123 Vine StreetG St. LouisH
45678-3333J
123-456-7890K
MidwestL
01-10X
Baker HallZ
Developing Self Discipline`
For Women Onlya
Keeping Fitb
Improving Your Memoryc
Stretching Your Dollarsd
Finding a New Jobe
Starting Your Own Businessf
Helping Othersh
25l Mr. Jamesm
Familyt
8/4/95| Area tour
Jill Smith
Spouse
9/15/97
P Dave Rahn
Ray Seilhamer
Mark Lamport
Ron Ramsey
9/15/97
9/26/97
8/16/59
How to Pay
|MMr. James W. Smith
123 Vine Street
St. Louis, MO 45678-3333
Dear Mr. James:
Baker Hall
Smith, James W.
James W. Smith
Developing Self Discipline
Keeping Fit
Family Budgeting
For Seniors Only
Stretching Your Dollars
Planning for Retirement
St. Louis, MO 45678-3333
St. Louis, MO
$25 [Area tour]
Baker Hall
Mr. James W. Smith
SmithF
123 Vine StreetG St. LouisH
456788
Smith
Insert Today
s Date in...
e.Has a letter been sent to this person already?
Help--Group CodesB
Sort/Amount Paid
Sort/Total Cost
Roomate Pref index
Increase Help ID Number by 1
Developing Self Discipline
Summary InfoB
Label Set-upB
Staying in Dorm
General
Handling Own Lodging
Income
Housing
Meals
Registration Fees
Total Registrants
Total to be Paid
Total Paid
l Total Due
Main Entry
Print
Find All
The numbers which appear apply only to the records in the current found set. If you want to see the figures for ALL records, hit the FIND ALL button below.
Find All
Summary
Labels
General
Handling Own Lodging
Income
Housing
Meals
Registration Fees
Total Registrants
Summary Info
Total to be Paid
Total Paid
l Total Due
Large Labels/5163B
Nametags
(3x4)
Small Labels
(Av #5160)
Large Labels
(Av# 5163)
Large Labels
(Av #5163)
Small Labels
(Av #5160)
Main Entry
Labels
Print
Confirm
Letter
Sort by:
Preview
:A preview will appear. If it
s correct, press
Continue.
Go to List
Print
UNUSED
UNUSED
People & Addresses
Payees Only
All Payees
#Payees Needing
Confirmation Letters
All Registrants
Summary
CA preview will appear to show what it will look like when printed.
Label Return Address
DType the return address you want to appear on all Avery 5163 labels.
{ arc
radindex numsteps1 ne
xt yt
radindex 1 add
numsteps1 dup 0 eq {pop} {div} ifelse
1 exch sub
radius mul halfstep add
dup xt add yt moveto
360 0 arcn
}stopped
{cleartomark exch 1.3 mul dup setflat exch 2 copy gt{stop}if}
{cleartomark exit}ifelse
}loop
gsave stopped grestore
{exch pop 2 index exch 1.3 mul dup 100 gt{cleartomark setflat stop}if}
The text here tells about renumbering the registration numbers. When you're done reading it, click the "Continue" button to the far left and you'll go back to the Codes screen.C
Note/Setup on Codes screen
starting a new file or convention, you need to: record the name of the meeting, record the names of seminars (if you have them) in the file SeminarTitles, and record the seminar schedule in SeminarTimes.B+
If you're starting a new file or convention, you need to: record the name of the meeting, record the names of seminars (if you have them) in the file SeminarTitles, and record the seminar schedule in SeminarTimes.B+
) = 1
ffff
Cancel
If you click on a seminar title, it will be inserted at the appropriate place in the list on the left (Seminar Titles), showing that the person has registered for it.
Note/Seminar Portal List
Cancel
If you click on LIST, it'll find all persons registered for that particular seminar, and will list them for you. Ready to print out.
Sort/Total Due
Dealing
= "1"
= "2"
= "3"
= "4"
= "5"
= "6"
= "7"
= "8"
= "9"
= "10"
= "11"
= "12"
= "13"
= "14"
Note/Seminar Portal
Sort/Seminar 13
Open Conventions
Open Seminar Titles
Open Seminar Times
Test/Copy-Paste Seminar
COMPANY NAME
CONFIRM LTTR SENT
CONFIRMATION RETURN ADD
COUNTRY
DEAR MESSAGE
DEAR....
EMAIL ADDRESS
ENTRY DATE
FAX NUMBER
GLOBAL 1
GLOBAL 2
GLOBAL 3
GLOBAL 4
GLOBAL RADIO BUTTON
GRADE
GRAND TOTAL DUE
GRAND TOTAL DUE\SUM
GRAND TOTAL INCOME
GRAND TOTAL INCOME\SUM
GRAND TOTAL PAID
GRAND TOTAL PAID\SUM
GRAPHIC?
GROUP LETTER
GROUP\FAMILY CODE
HANDLING OWN LODGING
HELLO!
HELP HEAD\SET
HOUSING FEE
HOUSING FEE PAID
HOUSING: DORM
HOUSING: DORM ROOM
HOUSING: OTHER
LABEL RETURN ADDRESS
LAST MODIFIED
LETTER ALL COSTS
MEAL FEES PAID
MEAL NOTES
MEALS?
MEETING CODE
MESSAGE\HOUSING
MISC. NOTES
NAME: FIRST
NAME: LAST
NAME: MIDDLE
NAME: PREFIX
NAME\FIRST PLUS LAST
NAME\LAST PLUS FIRST
NUMBER OF PERSONS
OTHER 1 COST
OTHER 1 DATE PD
OTHER 1 NOTES
OTHER 1 PAID
OTHER 2 COST
OTHER 2 DATE PD
OTHER 2 NOTES
OTHER 2 PAID
OTHER 3 COST
Yesf6
Yesf6
Sem 2B
t Investingf
Planning for Retirementh
Mrs. Jamesm
Familyt
8/4/95| Area tour
James Smith
Spouse
M#Is a diabetic. Needs special meals.
7/3/97
P Dave Rahn
Ray Seilhamer
Mark Lamport
Ron Ramsey
8/6/95
8/6/97
2/12/61
|FMrs. Jill Smith
123 Vine Street
St. Louis, MO 45678
Dear Mrs. James:
Baker Hall
Smith, Jill
Jill Smith
St. Louis, MO 45678
St. Louis, MO
$0 [Area tour]
AdamE
SmithF
123 Vine StreetG St. LouisH
45678J
123-456-7890K
MidwestL
Mr. and Mrs. James SmithQ
123 Vine StreetR St. LouisS
45678U
234-567-9012V
Vision
01-12X
Baker HallZ
Developing Self Discipline`
Keeping Fita
Family Budgetingb
For Seniors Onlyc
Men in Midlifed
Community Servicee
Starting Your Own Businessf
Helping Othersg
Cancel
You'll use this in the salutation of the confirmation letter. Type one of these in the blank, with no colon:
1. First name only (Dear Bill)
2. Title and last name (Dear Ms. Jones, or Dr. Smith)
Message--Introduction
Cancel
m Steve, and I love FileMaker.
ve designed a whole lot of FileMaker databases. This one was originally created for the various conferences, seminars, conventions, and other events hosted by the organization which writes my bi-weekly paychecks. I posted the initial version in 1995, and now it
s being used in a wide variety of settings-- colleges, businesses, nonprofit groups, civic groing for File
TODAY'S DATE
TOTAL COST
( TOTAL DUE
TOTAL HOUSING
TOTAL MEALS
TOTAL REG FEES
TOTAL REGISTRANTS
TOTAL REGISTRANTS
= "1"
= "2"
= "3"
= "4"
= "5"
="6"
= "7"
= "8"
= "9"
= "10"
Maker 3.0 and applied a tabs metaphor. Since then I
ve tinkered around with it various times, making a variety of further refinements. That brings us up to version 2.2.
If you decide you like this database and send me $20, I
ll send you the password so you can fully use it and customize it to your heart
s content. But whoa! You
re nowhere near that point yet. You downloaded this just to take a look and see what it was all about. You can click on the button at the bottom, or keep readinC
So here
s a little of what it has.
Information on attendees, of course--name, address, phone, age, sex, email, etc.
Payment information, including how much they
ve paid and how much they still owe.
Lodging info, whether they
re staying at your facilities or somewhere else. Room assignments and roommate preferences.
Confirmation letters which include what the person has paid and still owes.
Some pretty good help screens built in.
A screen with summary information on the event--h
ow many people have registered, how many are signed up for meals or lodging, how much money has come in so far, how much hasn
t, etc.
You can do several types of labels, including nametags.
Places for eight seminar time slots, with any number of seminars in each.
All kinds of ways to sort information.
You can customize this database to pieces, tailoring it to fit your specific needs and adapting it to fit different types of events as they arise.
If you want the password so you can fully use this database, you can send $20 in one of two ways:
1. Send $20 (check or cash) directly to me at:
Steve Dennie
3014 Carrington Dr.
Fort Wayne, IN 46804
sdennie@kagi.com (or, second choice, sdennie@ub.org)
Include your email address, if you have one, and I
ll send the password that way.
2. Use the bundled
Register Conventions
application to pay through Kagi Shareware (which manages the payment process for sharewa
\re authors).
Kagi offers a number of payment options, including credit cards and a First Virtual account. They
ll keep $2 for themselves, but that
s okay with me if it makes it easier for you to buy this file.
After you register, I
ll be glad to answer questions or give advice via email. Also, I
ll notify you via email about updates I make.
After getting the password, you
ll want to do the following:
1. Set up your own value lists (like dormitory names). To do that:
Go into Layout mode (Command-L).
Click once on the field you want to change. That selects the field.
Choose
Field Format
from the
Format
menu.
In the box that appears, click the second radio button, next to the words
Pop up List
Check boxes.
To the right, after the words
using value list,
is a drop-down box. Note the list th
s currently displayed. That
s the one you want to change. Then Choose the very last item, which is
Define value lists....
In the list in the upper left, select the list you want to change. Replace the items listed with your own list.
Hit the
button. Then get out by hitting the
button.
2. Get rid of the password protection. To do that:
Use the password to get into this file. That
s obvious.
From the File menu, go to
Access Privileges
and then choos
Define Passwords...
Select the password name which I sent you, and then hit the
Delete
button.
Select the (no password) entry, and then click in the box to the right which says
Access Entire File.
Hit the
Change
button, and then the
button.
You should now be able to get into the file without entering a password.
3. Get rid of this screen. To do that:
From this screen, go into Layout mode.
From the Mode menu, choose
Delete Layout.
ll be as
ked if you really want to do this. You do.
From the Edit menu, choose
Preferences.
In the box that appears, there
s a drop-down box. Choose
Document.
A few lines down, you can determine which layout you want the file to open onto when you first get into the file (after the words
Switch to layout
). I suggest setting it onto the layout
Personal Info.
By the way: The information in this screen will still be available after you delete the layout. There
s a field called
Hello!
which is a global field, meaning it contains the same information in every record. Just place the field onto a layout, and you
ll be able to read this message. Of course, you might also want to just delete this field entirely from the
Define Fields
menu, to get it out of your way. Doesn
t matter to me.
Codes
Personal
Housing
Seminars
Other Notes
Payment
UNUSED
Thursday
Thursday
Thursday
Thursday
Friday
Friday
Saturday
Saturday
10:00
11:00
10:00
11:00
re delighted that you
ve decided to attend the FileMaker International Convention. It will be a great time for everyone.
Here is your billing information:
Set Introduction
Set What This Does
Set How to Pay
Set After You Pay
Preview Letter
Print Letter
A Note\List
Cancel
The arrow below will take you to that person's record in Main Entry. You can sort these records by any of the headings on the right.
Sort/Lodging and Room #
Maker 3.0 and applied a tabs metaphor. Since then I
ve tinkered around with it various times, making a variety of further refinements. That brings us up to version 2.2.
If you decide you like this database and send me $20, I
ll send you the password so you can fully use it and customize it to your heart
s content. But whoa! You
re nowhere near that point yet. You downloaded this just to take a look and see what it was all about. You can click on the button at the bottom, or keep readinC
ups, professional organizations, blah blah blah.
In mid-1996, I totally overhauled the thing for FileMaker 3.0 and applied a tabs metaphor. Since then I
ve tinkered around with it various times, making a variety of further refinements. That brings us up to version 2.2.
If you decide you like this database and send me $20, I
ll send you the password so you can fully use it and customize it to your heart
s content. But whoa! You
re nowhere near that point yet. You downloaded this just tCho take a look and see what it was all about. You can click on the button at the bottom, or keep reading.